SELECT
t.permission_id
, t.permission_code
, t.NAME
, t.PARENT_ID
, t.PARENT_CODE
FROM c1_permission t
WHERE t.state_code = '1' and t.data_state_code = '1'
ORDER BY t.ORDER_BY_, t.permission_code
